| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Somerset Mahm
Somer's Omnibus Exploration and Reclamation
Cognitive Distortion
65
   |
Posted - 2011.12.06 22:16:00 -
[1] - Quote
Hiya Dragonaire,
So I'm about to make the leap to new-API-key Yapeal. What's the preferred way to migrate data? Do I have to set up a new database and manually run queries to change formats? Will Yapeal upgrade schemas for me if I rerun createMySQLTables (and preserve data)?
Just taking it slow :P |
Somerset Mahm
Somer's Omnibus Exploration and Reclamation
Cognitive Distortion
65
|
Posted - 2011.12.07 04:25:00 -
[2] - Quote
Yeah, *walletJournal and *walletTransactions are the ones I'm really concerned with. Thanks! |
Somerset Mahm
Somer's Omnibus Exploration and Reclamation
Cognitive Distortion
67
|
Posted - 2011.12.14 05:47:00 -
[3] - Quote
Alrighty, I did some tests on a copy of my DB and it looks like dropping all my account*, eve*, and util* tables and then rerunning createMySQLTables.php does the trick.
If schema changes are made to existing tables, does createMySQLTables update them? Or do I have to do any schema updates manually? (Just planning ahead) |
Somerset Mahm
Cognitive Distortion
94
|
Posted - 2012.04.04 06:17:00 -
[4] - Quote
+1 for Mercurial though I do wish you would use Bitbucket instead of SourceForge :P
SOMER Blink
Over 1,000,000 Blinks completed for over 130 Trillion ISK! |
Somerset Mahm
Cognitive Distortion
121
|
Posted - 2012.09.26 05:12:00 -
[5] - Quote
Hello!
I am (finally) running shiny latest Yapeal with CAK :P
Everything is working fine, but I have set the log level all the way to "debug" and I still am getting nothing in the logs at all. My config entry is:
log_config=YAPEAL_CONFIG "logger.xml"
SOMER Blink
Microlotteries that finish in minutes! Running for almost 2 years :) |
Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.11.30 06:43:00 -
[6] - Quote
I just got this same error on a new server with Yapeal as well.
Quote:Unknown cipher in list: AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.11.30 07:35:00 -
[7] - Quote
Sorted it out. It's because curl on this server isn't compiled with OpenSSL:
Quote:curl --version
curl 7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.13.1.0 zlib/1.2.3 libidn/1.18 libssh2/1.2.2
I just commented out these lines for now :P
Quote:
//$this->options['CURLOPT_SSL_VERIFYPEER'] = 1; // verify ssl certs
//$this->options['CURLOPT_SSL_VERIFYHOST'] = 1; // verify ssl host
//$this->options['CURLOPT_SSL_CIPHER_LIST'] = 'AES128-SHA AES256-SHA DES-CBC3-SHA RC4-SHA RC4-MD5'; // use these ciphers only
//$this->options['CURLOPT_CAINFO'] = YAPEAL_CONFIG . 'eveonline.crt';
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
125
|
Posted - 2012.12.04 01:07:00 -
[8] - Quote
Will Yapeal's curl implementation take advantage of GZIP API responses when they come out in a few weeks, or do I need to tweak the config? :)
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
149
|
Posted - 2013.01.28 21:16:00 -
[9] - Quote
You're checking utilSections, but it looks like you've defined a database prefix of EVE- in yapeal.ini. Try removing the prefix.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
165
|
Posted - 2013.06.04 20:26:00 -
[10] - Quote
I'd be happy to PLEX your account to keep a line of contact open.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
167
|
Posted - 2013.06.26 18:04:00 -
[11] - Quote
Ogads, the API changed and now Yapeal is broken. Time to put on my big kid pants and try to figure out how to change the schemas.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
167
|
Posted - 2013.06.26 19:16:00 -
[12] - Quote
I did it yay. I'll post a diff soon with the needed changes to get your Yapeal working once more. It's basically just updating xml and table schemas.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
168
|
Posted - 2013.06.26 22:56:00 -
[13] - Quote
Dragonaire is going to add me as a committer so I can at least try to help Yapeal limp along for now.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.27 05:16:00 -
[14] - Quote
I have pushed a change that should get Yapeal working again.
Update Yapeal (via hg pull or by downloading yapeal-latest.zip) and re-run install/createMySQLTables.php
This should be a non-destructive operation but you should backup your Yapeal data first if it is valuable.
Yapeal then should start to work once more.
I have NOT added the new "KillMails" API and will see if I can figure that out.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.27 16:41:00 -
[15] - Quote
Hmm, so there are two types of ContactList row types: one that's used for personal contact lists, which should always have a watchlist attribute, and one which is used for corp and alliance contacts lists, which has no concept of a watchlist.
All the schemas appear to be set up to validate this concept correctly. I'll test it against more of my own keys but they seem to work.
I wonder if really old contacts didn't have a watchlist attribute. Will check into it.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.27 16:42:00 -
[16] - Quote
Nope, you're right. On at least one of my keys, no watchlist attribute shows up at all. API bug.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.06.30 19:22:00 -
[17] - Quote
First, check the table accountAPIKeyInfo[/'b] nnd [b]accountCharacters to see what Yapeal thinks about the keys.
If the info there looks correct and you see 4 keys, next check utilRegistered* to make sure you haven't provided overrides to the masks and that the keys are set to active = 1.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 17:22:00 -
[18] - Quote
Chian XinLian wrote:Any help?
I've downloaded yapeal-latest, unpacked it on top of the old yapeal setup and ran install/createMySQLTables.php.. Still everytime yapeal runs, I get pile of errors like these:
Those were definitely fixed in the latest download :) a couple things off the top of my head:
Are you sure you ran createMySQLTables and not createMySQLDatabase? Did it say it completed without errors?
Does the MySQL user that Yapeal runs under have permission to alter tables?
In the table corpWalletJournal, do the fields "owner1TypeID" and "owner2TypeID" exist?
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 21:05:00 -
[19] - Quote
Hmm. I verified that createMySQLTables.php properly upgrades a database under my environment.
Last diagnostic question: In install/corp.xml, do you get any results if you search for "owner1TypeID"? (Ensuring that you didn't somehow get a bad download from Sourceforge)
If you get a result for that search, then you have the latest Yapeal version but Yapeal is not properly upgrading the table and that's beyond my current level of investigation. What versions of PHP and MySQL are you using?
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 21:45:00 -
[20] - Quote
\o/
If you feel up to it, the best way to grab updated Yapeal is to set up Mercurial. Then whenever a new version comes out you can do "hg pull -u" and it'll update things automatically for you.
Hope it's all sorted now!
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.01 23:56:00 -
[21] - Quote
I'm working on support for the new KillMails API and will try to push a new release in the next day or two.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
170
|
Posted - 2013.07.02 22:52:00 -
[22] - Quote
Pushed a new version.
Yapeal Odyssey-1.0.12
* Added support for cURL compiled with NSS instead of OpenSSL support.
* Added KillMails API and removed KillLog API.
If you have old mails in the KillLog table, dump them to disk before upgrading as the KillLog API has been deprecated and will be removed when you upgrade your Yapeal db schema.
Download the latest Yapeal files (or use Mercurial, recommended!). After backing up your KillLog table, if desired, run install/createMySQLTables.php to upgrade your db schema.
If you get SSL errors, please let me know the output of curl --version on your machine.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.03 19:52:00 -
[23] - Quote
corpMemberTracking requires the MemberTrackingExtended permission. Currently MemberTrackingLimited is not supported.
Make sure your key provides this permission and that any bitfield set in utilRegisteredKey encompasses the proper bitmask.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.04 18:31:00 -
[24] - Quote
CharacterSheet does not contain this info. Corp/MemberTrackingExtended does, but that's a corp key you need.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
171
|
Posted - 2013.07.09 04:54:00 -
[25] - Quote
PHP CLI is because Yapeal is meant to be run via cron.
I don't quite grok the first part of your question-- do you mean you need to create the db tables? If so, you can do this by running install/createMySQLTables.php
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.14 20:03:00 -
[26] - Quote
Erica Northman wrote: WARN: Caching invalid API XML for corp/CorporationSheet
Im getting this error. Any idea how to fix this ?
Thanks for the report! I've committed a new Yapeal version. To upgrade:
Download the new version and replace your copy of Yapeal (or use Mercurial, recommended!)
Run install/createMySQLTables.php to update the table schema.
Changelog:
- Change CURLOPT_SSL_VERIFYHOST to 2 as the previous behavior has been deprecated in the latest versions of libcurl and PHP is now throwing a deprecation notice.
- Add new "FactionID" column to corp/corporationSheet. If a corporation participates in faction warfare, their chosen faction will be here.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.14 20:12:00 -
[27] - Quote
Tiberius Zol wrote:Hi.
Is there any possibility to run yapeal without PHP CLI?
My provider doesn't support CLI despite the fact he allow to create cron jobs.
If you can create cron jobs, can you set yapeal to run as a cronjob?
Something like */1 * * * * /usr/bin/php53 /home/tiberius/yapeal/yapeal.php
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
172
|
Posted - 2013.07.15 22:53:00 -
[28] - Quote
You're getting an error that the "MySQL server has gone away", so something may be wrong with your config.
My first inclination would be to blow away your setup and try starting fresh, as when I do the steps from my dev environment everything seems to work and I get rows in corpCorporationSheet.
Sorry I can't be more help!
[somer ~]$ mysql --version
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1
[somer ~]$ php53 --version
PHP 5.3.24 (cli) (built: Apr 25 2013 08:01:58)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.19 17:33:00 -
[29] - Quote
I rely on corpWalletJournal heavily so it's probably my most-tested piece. The API has not changed for it in any way that I know, and I'm still receiving wallet data.
I would first make sure that your key's access mask is correct and that the key is still active in utilRegisteredKeys. Very rarely (every 2-3 months for me usually) the API has horked an error that causes Yapeal to think the key is no longer valid, which makes it deactivate it. You'll see this error in your logs as well.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.20 01:34:00 -
[30] - Quote
Yes, I think there is a feature somewhere that will deactivate single APIs if they throw certain errors that say you don't have permission (which is an API failure, not your fault or Yapeal's fault).
One of the ideas I have for Yapeal is a sort of status dashboard or heath check where you can quickly see what is working and when it was last updated. So that might help you in the future.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
182
|
Posted - 2013.07.20 17:49:00 -
[31] - Quote
Without a bug reporting system I was reduced to tweeting at PrismX and haven't gotten a reply.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
184
|
Posted - 2013.07.21 20:00:00 -
[32] - Quote
403 means your credentials are invalid or you sent a bad request. Did your API key expire? They normally have an expiry of a year.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
185
|
Posted - 2013.08.02 06:37:00 -
[33] - Quote
I use Yapeal to track almost 20 characters' worth of jobs. What kind of keys are you using to track the jobs?
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
185
|
Posted - 2013.08.04 23:13:00 -
[34] - Quote
As long as you make valid requests CCP has no limiting in place. You only get in trouble if you make invalid requests like trying to scrape character names, etc.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
186
|
Posted - 2013.08.07 04:20:00 -
[35] - Quote
I believe Yapeal only operates on the full-permissions CorporationSheet. I'll take another look.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
195
|
Posted - 2013.08.31 18:28:00 -
[36] - Quote
This is an artifact of the new system PrismX has set up where it uses actual HTTP error codes.
I will fix this so Yapeal handles them correctly.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
195
|
Posted - 2013.09.04 04:11:00 -
[37] - Quote
Yep, if you just unzip a copy over the top it will have old files.
The safest way to upgrade, if you can, is to set up a Mercurial clone and sync when updates are released.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
197
|
Posted - 2013.09.13 01:33:00 -
[38] - Quote
Sabeca wrote:Hi,
is there any way how i can easly check if a api key + V-Code is valid without insert him into the database?
I want to insert a login and registration to my homepage wich give a error while the registration when the combination isnt valid.
greeting Sabeca
Yapeal isn't designed to do this. You'll want to either use something like Pheal, which is just a wrapper around calls to the API directly, or even just make this call yourself and manually parse the result.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
200
|
Posted - 2013.10.08 21:20:00 -
[39] - Quote
qu1ckkkk wrote:Somerset Mahm wrote:This is an artifact of the new system PrismX has set up where it uses actual HTTP error codes.
I will fix this so Yapeal handles them correctly. I'm curios on how you are going to go about this? Will setting a key to no longer being active in utilRegisterdKey be a viable option if the call goes 403 Forbidden for API https://api.eveonline.com/account/APIKeyInfo.xml.aspx ?
That is my plan; Yapeal handles the old behavior in just this way. So it's just a matter of moving the error-handling logic up a level since now the error is at the HTTP level.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
200
|
Posted - 2013.10.09 16:35:00 -
[40] - Quote
I personally have a two-layer system-- I fetch id->name pairs and store them in a db and also store them in a memcache instance.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
221
|
Posted - 2014.01.05 22:24:00 -
[41] - Quote
I use corpContracts every day, so it's definitely working in the latest build. I'd make sure that your table structure is up to date (maybe try a fresh install to test).
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
222
|
Posted - 2014.01.06 20:54:00 -
[42] - Quote
I will try to find you in game and have a chat, corpContracts is super useful.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
225
|
Posted - 2014.01.15 23:28:00 -
[43] - Quote
In cases like Eveboard or a corp where you want to load data sort of on-the-fly, unfortunately Yapeal doesn't have a good mechanism to do this built-in. I would suggest a simple script that goes through utilRegisteredChar and sets isActive to 0 for all except the one that you want, then runs Yapeal.
If your primary use case is this on-demand sort of thing, honestly Yapeal is probably not the best choice.
I use a simple locking mechanism to ensure that Yapeal doesn't collide-- I touch a lockfile in my homedir before running Yapeal, and exit if the lockfile still exists. When Yapeal is done, I remove the lockfile.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
226
|
Posted - 2014.01.21 23:11:00 -
[44] - Quote
Zynen wrote:Thanks for making and maintaining yapeal! Question - I'm looking at this API Call - http://wiki.eve-id.net/APIv2_Corp_StarbaseDetail_XMLAnd I can't find the data anywhere in Yapeal. I see corpStarbaseDetail, where I think it should be. But it's nearly a mirror of corpStarbaseList. I don't see any of the combat settings, etc. Can anyone tell me where to find corpStarbaseDetail information in Yapeal? I checked SourceForge Issues, but I didn't see it listed. So perhaps I'm just missing something.
They get extracted into several sibling tables. For example combat settings for POSes are in corpCombatSettings, and there is a posID field that you can reference.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
232
|
Posted - 2014.06.02 02:10:00 -
[45] - Quote
Which rows have useful history? Stuff like walletjournal is immutable, and I generally only care about the current state of a contract.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
Somerset Mahm
Cognitive Distortion
232
|
Posted - 2014.06.02 20:49:00 -
[46] - Quote
Dragonaire wrote:True for some APIs doesn't really matter one that we talked about is AssetList where you'd maybe be able to do audits on where stuff goes etc. MarketOrders might be interesting to as you could see how quickly something is selling or coming in which might be useful. Might be a couple others as well.
I can see the value but to me Yapeal is just an interface between the API and a database; I don't really want it to show data that isn't in the API.
SOMER Blink
Microlotteries that finish in minutes! Running for over 2 years :) |
| |
|